Create a new table space that uses the new buffer pool. 创建一个使用这个新缓存池的新表格空间。
This means that DB2 fetches every data page in the table space sequentially into the buffer pool. 这意味着DB2按顺序在表空间上提取每一个数据页面到缓冲池。
The above example shows a good buffer pool hit ratio of98.4%. 以上示例显示了98.4%的良好缓冲池命中率。
Subsequent users may often find some of these resources in the buffer pool. 随后的用户则常常可以发现有些资源已经在缓冲池中。
The buffer pool hit ratio is now showing excellent results. 现在的缓冲池命中率就显示了较好的结果。
You can filter on buffer pool name, partition number, and other properties. 您可以根据缓冲池名称、分区编号和其他属性进行过滤。
This improves performance for these LOBs because you can access them through the buffer pool. 这提高了这些LOB的性能,因为可以通过缓冲区池对其进行访问。
Having more than one buffer pool can preserve data in the buffers. 拥有多个缓冲池可以将数据保存在缓冲区中。
This requires the appropriate index pages to be in the buffer pool. 这要求在缓冲池中存在适当的索引页。
Buffer Pool, I/ O, and Page Cleaning 缓冲池、I/O和页清除
A table space can only use one buffer pool. 一个表空间只能使用一个缓冲池。
Note that the page sizes of8K for the buffer pool and table space are the same. 请注意,缓冲池和表空间的页大小都是8K,两者是相同的。
Each database requires at least one buffer pool. 每个数据库都至少需要一个缓冲池。
In this case, we will trace only the buffer pool services component. 在本例中,我们将只跟踪缓冲池服务组件。
This allows buffer pool caching to take place. 这允许发生缓冲池的缓存。
This makes it easier to update and report the buffer pool size along with other DB2 database configuration parameters. 这使得更新和报告缓冲池大小以及其它DB2数据库配置参数变得更加方便。
Buffer pool contention can be a significant factor in database performance. 缓冲池竞争可以成为数据库性能中的重要因素。
The more page requests that can be satisfied by a buffer pool, the better query performance will be. 一个缓冲池可满足的页面请求越多,将得到越高的查询性能。
Each page with inserted rows will eventually be written from the buffer pool to disk. 插入了新行的每一页最后都要从缓冲池写入到磁盘。
They are useful to understand buffer pool, I/ O and temp space usage of your XML data. 它们对于了解XML数据的缓冲池、I/O和临时空间的使用情况很有用。
Most notably is the change of the size of the default buffer pool. 最值得注意的是对缺省缓冲池大小的修改。
Use one buffer pool, but increase its size until the index hit ratio stops increasing. 使用一个缓冲池,但是增加其大小直至索引命中率停止增长。
These types of columns are unique in that they are not cached in the buffer pool. 这些类型的列是惟一的,它们不会缓存在缓冲池中。
The accounting reports show the number of GETPAGES and synchronous reads per buffer pool. 会计报表显示对应于每个缓冲池的GETPAGES和同步读的数量。
Another configuration parameter that dramatically affects performance is the database buffer pool size. 另一个极大影响性能的配置参数是数据库缓冲池大小。
That means DB2 cannot start the database, because a database must have at least one buffer pool. 这意味着DB2无法启动数据库,因为一个数据库至少必须有一个缓冲池。
This calculation takes into account all of the pages ( index and data) that are cached by the buffer pool. 这个计算考虑了缓冲池高速缓存的所有页(索引和数据)。
The DBA resolved the problem by reducing the buffer pool size and other memory parameters. 通过减少缓冲池大小和其它内存参数就能解决这个问题。
Number of requests per second to find a page in the buffer pool. 每秒要求在缓冲池中查找页的请求数。
Number of seconds a page will stay in the buffer pool without references. 页若不被引用将在缓冲区池中停留的秒数。